package cn.itcast.bassm.mapper;

import java.sql.Timestamp;
import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.itcast.bassm.pojo.Location;
import cn.itcast.bassm.pojo.Timeend;
import cn.itcast.bassm.pojo.Unitdoor;
import cn.itcast.bassm.pojo.Uploadfile;
import cn.itcast.bassm.pojo.User;
import cn.itcast.bassm.pojo.UserInformation;
import cn.itcast.bassm.pojo.Usero;
import cn.itcast.bassm.pojo.Visitors;
import cn.itcast.bassm.pojo.pathuser;

public interface UserMapper {
	public User queryUserById(@Param("id")int id);
	
	public User queryUserByPowrd(@Param("yusername")String yusername,@Param("ypassword")String ypassword);
	
	public void addUserInformation(@Param("urlimglist")String urlimglist,@Param("imgurl")String imgurl,@Param("name")String name,@Param("sex")String sex,@Param("phong")String phong,@Param("sfzid")String sfzid,@Param("detailed")String detailed,@Param("state")int state);
	
	public Uploadfile addqueryUserById(@Param("yid")String yid);
	
	public void updateUserState(@Param("id")int id,@Param("yindex")String yindex,@Param("idnumber")String idnumber,@Param("updatetime")String updatetime);
	
	public long getProductsCount(@Param("yaddress")String Celladdress1);
	
	public long getnotProductsCount(@Param("yaddress")String Celladdress1);
	
	public long getyesProductsCount(@Param("yaddress")String Celladdress1);
	
	
	public long getProductsCountczy(@Param("yaddress")String Celladdress1);
	
	public long getFastregistrationcardnumberrepeating(@Param("yaddress")String yaddress);
	
	public List<Uploadfile> selectProductsByPage(@Param("startPos")int startPos,@Param("yaddress")String Celladdress1,@Param("pageSize")int pageSize);
		
	public List<Visitors> selectProductsByPageczy(@Param("startPos")int startPos,@Param("yaddress")String Celladdress1,@Param("pageSize")int pageSize);

	
	public List<Uploadfile> selectFastregistrationcardnumberrepeatingPage(@Param("startPos")int startPos,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public void savexdurl(@Param("scenePath")String scenePath,@Param("Timestamptime")Timestamp Timestamptime);
	
	public void deleimg(@Param("yid")String yid);
	
	public Uploadfile selectFinPhoneorUserName(@Param("yphone")String phonename,@Param("yname")String nameonefin);
	
	public List<Uploadfile> selectnameonefinPage(@Param("startPos")int startPos,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Uploadfile> selectFinPhoneorUserNameu(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public List<Uploadfile> selectallFInPage(@Param("startPos")int startPos,@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress,@Param("pageSize")int pageSize);
	
	public long getProductsCount2(@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public long getProductsCount3(@Param("yphone")String yphone,@Param("yaddress")String yaddress);
	
	public long getProductsCount4(@Param("yphone")String yphone,@Param("yname")String yname,@Param("yaddress")String yaddress);
	
	public List<Unitdoor> selecUnitdoor(@Param("address")String address,@Param("number")String number);
	
	
	public List<Unitdoor> selecUnitdoorczy(@Param("address")String address,@Param("number")String number);

	
	public List<Uploadfile> selecfinuserlou(@Param("yid")String yid);
	
	public Uploadfile selecfinuserlouto(@Param("yid")String yid);
	
	public void UpselectFinto(@Param("yname")String yname,@Param("ydetailed")String ydetailed,@Param("yid")int yid,@Param("updatetime")String updatetime,@Param("cardnumber")String cardnumber,@Param("yidcar")String yidcar,@Param("roomandnumber")String roomandnumber,@Param("unitbuilding")String unitbuilding);
	
	public void UpselectFintotime(@Param("yindex")String yindex,@Param("idnumber")String idnumber);
	
	public void savekahaouser(@Param("yname")String yname,@Param("ysex")String ysex,@Param("cardnumber")String cardnumber,@Param("yaddress")String yaddress,@Param("ydetailed")String ydetailed,
								@Param("yindex")String yindex,@Param("idnumber")String idnumber,@Param("updatetime")String updatetime,@Param("examine")String examine);
	
	public Uploadfile secletusergunone (@Param("yid")String yid);
	
	public Timeend secleTimeEnd (@Param("id")String id);
	
	public void uptimeend(@Param("timesetend")String timesetend ,@Param("id")String id);
	
	public void upexamine(@Param("examine")String examine ,@Param("yindex")String yindex ,@Param("yid")String yid,@Param("updatetime")String updatetime,@Param("idnumber")String idnumber);

	public void upexaminedele(@Param("examine")String examine ,@Param("yindex")String yindex ,@Param("yid")String yid,@Param("updatetime")String updatetime);
	
	public void upexaminetwo(@Param("examine")String examine ,@Param("yid")String yid,@Param("updatetime")String updatetime,@Param("idnumber")String idnumber);

	public Location seclectfinusermoeny(@Param("yaddress")String yaddress);
	
	public void savetestoneuser(@Param("yfilename")String yfilename,@Param("yname")String yname,@Param("ysex")String ysex,
			@Param("yowner")String yowner,@Param("yphone")String yphone,@Param("yaddress")String yaddress,
			@Param("ydetailed")String ydetailed,@Param("createtime")String createtime,@Param("updatetime")String updatetime,@Param("yindex")String yindex,
			@Param("ynumber")String ynumber,@Param("idnumber")String idnumber,@Param("examine")String examine);
	
	public void updatevistorsendtime(@Param("yupdatetime")String yupdatetime,@Param("state")String state);
	
	public List<Uploadfile> selcettoUploadfileandexamine(@Param("examine")String examine);
	
	public void uptoUploadfileandexamine(@Param("examineto")String examineto,@Param("nowtime")String nowtime,@Param("yid")String yid);
	
	public List<Uploadfile> chaxunuser();
	
	public List<Visitors> chaxunvisitors();
	
	public void deleteuserone(@Param("yid")String yid,@Param("updatetime")String updatetime);
	
	public long getProductsCountwubohui();
	
	public List<pathuser> selectProductsByPagewubohui(@Param("startPos")int startPos,@Param("pageSize")int pageSize);
	
	public void insertpathtuisong(@Param("pathtuisong")String pathtuisong);
	
	public void insetInterfacestate(@Param("name")String name,@Param("state")String state,@Param("timeend")String timeend);
	
	public List<Uploadfile> seleuserandcardnumber(@Param("cardnumber") String cardnumber,@Param("yaddress")String yaddress);
	
	public Usero seleusermima(@Param("ynumber") String ynumber,@Param("yaddress")String yaddress);
	
	public void upusermimato(@Param("ypassword") String ypassword,@Param("ynumber")String ynumber,@Param("yaddress")String yaddress);
	
	public List<Location> selectandLocationtoaddress ();
	
	public List<Uploadfile>	selectandUploadfiletoaddress (@Param("yaddress") String yaddress,@Param("starttime") String starttime,@Param("endtime") String endtime);
	
	public List<Visitors>	selectandvisitorstoaddress (@Param("yaddress") String yaddress,@Param("starttime") String starttime,@Param("endtime") String endtime);
	
	public void upandPublicandNumbertow(@Param("cardnumber") String cardnumber,@Param("yaddressna") String yaddressna,@Param("binding")String binding);

	public void upuserczy(@Param("yid")String yid,@Param("yindate")String yindate,@Param("yupdatetime")String yupdatetime);
	
	public void upandPublicandNumber(@Param("cardnumber") String cardnumber,@Param("yaddressna") String yaddressna,@Param("binding")String binding,@Param("yid")String yid);
}
